package com.cspg.ssss.service;

import com.cspg.ssss.repository.WordExMapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;
@Service
public class WordExService {
    @Autowired
    private WordExMapper wordExMapper;

    /*公司模板开始+++++++++++++++++++++++++++++++++++++++++++++++++++*/
    //问题总数
    public  int selectall(@Param("creattime")String creattime, @Param("endtime")String endtime){ return wordExMapper.selectall(creattime,endtime); }

    //问题发现方式列表
    public List<Map> selectst1(String creattime, String endtime){
        return wordExMapper.selectst1( creattime, endtime);
    }

    //问题部门分布情况
    public List<Map> selectst2(String creattime, String endtime){
        return wordExMapper.selectst2( creattime, endtime);
    }

    //问题专业类别分布情况
    public List<Map> selectst3(String creattime, String endtime){
        return  wordExMapper.selectst3(creattime,endtime);
    }

    //问题业务事项分布情况
    public List<Map> selectst4(String creattime, String endtime){
        return  wordExMapper.selectst4(creattime,endtime);
    }

   //问题所属层面分布情况
    public List<Map> selectst5(String creattime, String endtime){
        return  wordExMapper.selectst5(creattime,endtime);
    }

    //问题所属层面分布情况
    public List<Map> selectst6(String creattime, String endtime){
        return  wordExMapper.selectst6(creattime,endtime);
    }

    //问题类别分布情况
    public List<Map> selectst7(String creattime, String endtime){
        return  wordExMapper.selectst7(creattime,endtime);
    }

    //问题对应体系单元情况
    public List<Map> selectst8(String creattime, String endtime){
        return  wordExMapper.selectst8(creattime,endtime);
    }

    //问题对应体系要素情况
    public List<Map> selectst9(String creattime, String endtime){
        return  wordExMapper.selectst9(creattime,endtime);
    }

    //问题对应体系要素情况
    public List<Map> selectst10(String creattime, String endtime){
        return  wordExMapper.selectst10(creattime,endtime);
    }

    //是否三老问题总和
    public List<Map> selectst11(String creattime, String endtime){
        return  wordExMapper.selectst11(creattime,endtime);
    }

   //是否三老问题单位分布
    public List<Map> selectst12(String creattime, String endtime){
        return  wordExMapper.selectst12(creattime,endtime);
    }

    //是否主动暴露总和
    public List<Map> selectst13(String creattime, String endtime){
        return  wordExMapper.selectst13(creattime,endtime);
    }

    //是否主动暴露单位分布
    public List<Map> selectst14(String creattime, String endtime){
        return  wordExMapper.selectst14(creattime,endtime);
    }

    //问题整改总
    public List<Map> selectst15(String creattime, String endtime){
        return  wordExMapper.selectst15(creattime,endtime);
    }

    //单位整改
    public List<Map> selectst16(String creattime, String endtime){
        return  wordExMapper.selectst16(creattime,endtime);
    }

    //查询总验收
    public int selectzys(@Param("creattime")String creattime, @Param("endtime")String endtime){return wordExMapper.selectzys(creattime,endtime);}
    //查询单位问题
    public int selectdwwenti(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){return wordExMapper.selectdwwenti(creattime,endtime,dwmc);}

   /* 公司模板结束++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/

    /*  单位模板开始+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
    //单位问题总数（按单位名称查询）
    public int selectdwwentizs(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc)
    {
        return wordExMapper.selectdwwentizs(creattime,endtime,dwmc);
    }
    //单位问题发现方式分布
    public List<Map> selectdw1(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw1(creattime,endtime,dwmc);
    }
    //单位问题部门分布
    public List<Map> selectdw2(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdw2(creattime, endtime, dwmc);
    }
    //单位问题专业类别
    public List<Map> selectdw3(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdw3(creattime, endtime, dwmc);
    }
    //单位问题业务事项
    public List<Map> selectdw4(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw4(creattime, endtime, dwmc);
    }
    //单位问题所属层面
    public List<Map> selectdw5(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw5(creattime, endtime, dwmc);
    }
    //单位问题管理环节
    public List<Map> selectdw6(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw6(creattime, endtime, dwmc);
    }
    //单位问题类别
    public List<Map> selectdw7(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw7(creattime, endtime, dwmc);
    }
    //单位问题对应体系单元
    public List<Map> selectdw8(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw8(creattime, endtime, dwmc);
    }
    //单位问题对应体系要素
    public List<Map> selectdw9(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw9(creattime, endtime, dwmc);
    }
    //单位问题对应体系要素
    public List<Map> selectdw10(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdw10(creattime, endtime, dwmc);
    }
    /*单位模板结束+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
    public List<Map> selectdwsl1(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdwsl1(creattime, endtime, dwmc);
    }
    public List<Map> selectdwsl2(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdwsl2(creattime, endtime, dwmc);
    }
    public List<Map> selectdwbl1(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdwbl1(creattime, endtime, dwmc);
    }
    public List<Map> selectdwbl2(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return wordExMapper.selectdwbl2(creattime, endtime, dwmc);
    }
    public List<Map> selectDepartment(){
        return wordExMapper.selectDepartment();
    }
    public List<Map> selectdwzq1(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdwzg1(creattime, endtime, dwmc);
    }
    public List<Map> selectBmmc(String dwmc){return  wordExMapper.selectBmmc(dwmc);}
    public List<Map> selectdwzq2(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdwzq2(creattime, endtime, dwmc);
    }
   public  int selectdwys(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectdwys(creattime, endtime, dwmc);
   }
    public List<Map>  selectdwwtzsall(@Param("creattime")String creattime, @Param("endtime")String endtime){
        return  wordExMapper.selectdwwtzsall(creattime, endtime);
    }
    public List<Map>  selectdwysall(@Param("creattime")String creattime, @Param("endtime")String endtime){
        return  wordExMapper.selectdwysall(creattime, endtime);
    }
    public List<Map>  selectbmwtzsall(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectbmwtzsall(creattime, endtime, dwmc);
    }
    public List<Map>  selectbmysall(@Param("creattime")String creattime, @Param("endtime")String endtime,@Param("dwmc")String dwmc){
        return  wordExMapper.selectbmysall(creattime, endtime, dwmc);
    }
}
